EMT Practice Test

1. Question Content...

---

Question1: A developer identified duplicate contactsand initiated a Contact Delete process for 10 million subscribers.
How could the process be expedited?

Question2: When do synchronous REST API calls to Marketing Cloudtime out? Choose 2.

Question3: A developer is implementing a custom profile center and using the LogUnsubEvent request. Which parameter is required for the event to be tied to the appropriate send?

Question4: NTO is using a mobile campaign to collect an email addresses of interested subscribers. Using AMPscript's API functions they will send a confirmation email when an email is texted into their short code. Which two objects are required tosuccessfully create a TriggerSend object? Choose 2

Question5: A marketer is sending an email with dynamic content contained in a series of conditionals.
Which AMPscript function should be used to track the different versions of the content within the email?

Question6: A developer identified a use case where a triggeredsend of an email is needed. The developer already successfully set up authentication with a Client ID and Client Secret has used them in several REST calls.
When the REST call is made, a "401 Unauthorized" error is returned. What is the first thing the developer should check?

Question7: A developer needs to configure an Email Send Logging Data Extension for a new business unit. Which option should be used?

Question8: A developer created a landing page in CloudPages which return unique content when subscriber data is located on a related data extension. The developer does not know if all subscribers have rows in the related data extension, and want default content to render if no subscriber data is found on the related data extension.
Which best practice should the developer follow to control the unique and default content?

Question9: Which action could the RaiseError AMPscript function be configured to perform?

Question10: A developer wants to configure an automation to import files placed on the SFTP shared by a customer's data vendor. The automation will start when a file matching a specific namingpattern is encountered in the Import folder. The first step of the automation is a File Import Activity referencing a substion string for the matching file. Which substituon string represents the name of the file?

Question11: Which two ways would a developer write an Exclusion Script to exclude sending an email at send time when comparing against a Boolean field in the Sendable Data Extension?
Choose 2 answers

Question12: Which activity is required before a compressed file can be imported?

Question13: Northtrn Trail Outfitters has set up their North American business unit to unsubscribe at the business unit level.
Which dataview would they query to identify all subscribers who are unsubscribed from that Business Unit?

Question14: A developer wants to populate a data extension with information about all emails deployed in the last seven days. The data extension needsto contain JobID, EventDate, and the counts of how many emails were sent with each JobID.
Which data view is required to gather this information?

Question15: Certification Aid uses Marketing Cloud Connect and wants to create a lead capture form on a landing page.
When a customer submits the form, a Lead record should be created in Salesforce. Which scripting language can be used for this? Choose 2.

Question16: A developer is configuring a new Marketing Cloud account and has decided touse a unique 10-digit integer as each customer's Contact Key.
Which data type should be used when representing the value of Contact Key?

Question17: NTO had an Enterprise 2.0 account; subscribers unsubscribes from the business unit only. A developer is identifying subscribers who unsubscribed from any of the NTO child business units. Which method wouldidentify the most accurate status for subscribers of each business unit?

Question18: A developer is experiencing timeouts when testing a SQL Query Activity in Automation Studio. How should the developer optimize the query?

Question19: A developer wants to retrieve all recordsin the OrderDetails data extension which are associated with a particular customer.
Which two AMPscript functions would return a suitable rowset?
Choose 2 answers

Question20: When appending data to links via Web Analytics Connector, which parameter should be used to track subscriber behavior?

Question21: A developer wants to expand thefunctionality of existing code which was written in AMPscript, but prefers to use Server-Side JavaScript (SSJS) for updates.
Which SSJS statement will retrieve the value of the AMPscript variable named subKey?

Question22: A developer wants to include a comment within an AMPscript code block for the benefit of other developers who will be reviewing the code.
Which syntax should the developer use?

Question23: NTO is using an asynchronous SOAP API call to the TriggerSend object to send order confirmation email to their customers. Which API object and attribute should be used toretrieve the status of the API call?

Question24: How can subscriber, system, and sendable Data Extension attributes be referenced for content personalization using SSJS? Choose 1.

Question25: Why woulda developer use LookupRows Instead of the Lookup AMPscript function?

Question26: A developer needs to use the 'contacts/ route of the REST API to update records in a data extension.
What should the developer verify before making the API call?

Question27: A developer used LookupRowsto retrieve data when building a dynamic email.
What should be the next step before using this rowset within a FOR loop?

Question28: A field value returned from a DE lookupcontains a tab-delimited list of values. Which AMPscript function could easily determine if a specific text string exist anywhere in the list?

Question29: Northern Trail Outfitters wants to trigger follow upmessages after a subscriber opens an email.
What process would they use to get real-time engagement data?

Question30: Certification Aid wants to create Contacts in Marketing Cloud via API calls. Which API should be used for this? Choose 2.

Question31: NTO wants use Personally Identifiable Information (PII) data to personalize email communications, but does not want to store PII data in Marketing Cloud. Which feature could they use to personalize emails from an external data source?

Question32: NTO uses data extensions to manage the subscriber information usedfor their email sends, and those sends includes calls to update records with new or different subscriber information. The developer handling these records writes some AMPscript to check and see if the data extension containing those records updated usingan InsertDE() call if the record doesn't yet exist. Why would the developer receive an error stating the application cannot insert a duplicate value for the primary key in the data extension?

Question33: Which SSJS library can be used in email messages? Choose 1.

Question34: A developer wants to set a variable to use a field from a Sendable Data Extension.
Which two options could be used in an AMPscript block to set the variable as a 'First Name" field from a Sendable Data Extension usedto send the email? Choose 2 answers

Question35: Certification Aid wants to import data from a CSV file into a Data Extension. The CSV filecontains all relevant data. New records should be added to the Data Extension, and records which are not in the file should be removed from the Data Extension. Which import operation should be chosen for this? Choose 1.

Question36: Certification Aid wants to encrypt data stored in Marketing Cloud. It is fine if unencrypted fields arevisible to Marketing Cloud and Salesforce users, but the underlying data should be encrypted at rest to prevent physical data theft. Which encryption method should be chosen? Choose 1.

Question37: A developer is making an API REST call to trigger an email send. An accesstoken is used to authenticate the call.
How long are Marketing Cloud v1 access tokens valid?

Question38: A company needs to retrieve a large number of rows from a data extension via the API.
Which two solutions would optimize the performance?
Choose 2 answers

Question39: Certification Aid wants to update Contact data stored in a Data Extension using the REST API. What is required to achieve this? Choose 1.

Question40: A customer wants to export send data to their SFTP. Which two automationswould accomplish this? Choose 2

Question41: A developer is building a landing page in Marketing Cloud and an email with a Call-To page will display personal information about the subscriber.
In which way could the developer create the CTA link?

Question42: A developer is notified the View Email As Web Page (VAWP) link, when clicked, displays the message, The system is temporarily unavailable. We apologize for any inconvenience. Please try again later.
What could be a possible cause for the error

Question43: A developer is troubleshooting the cause of incomplete results in the link tracking data for an email send.
How should the RedirectTo AMPscript function be described as it relates to link tracking'

Question44: A developer is troubleshooting why a parent-level data extension cannot be accessed by a child business unit.
What should the developer check to validatethe data available can be accessed for child business unit queries?

Question45: Adeveloper is working on cross-channel campaign functions for the email team at Northern Trail Outfitters.
They are reviewing available APIs for the different Marketing Cloud applications to determine the most appropriate solution for each.
Which application utilizes the REST API?

Question46: A particular data extension need to be configured to store six months of data.
How shoulddata retention be added to the data extension in Email Studio?

Question47: A developer wants to populate a data extension with the date of the most recent click for each subscriber.
Which query would accomplish this?

Question48: A developer uses an API to send data to a Marketing Cloud data extension once every fiveminutes using the REST API. They notice data does not always write to the data extension, leading to data loss.
Which three best practices are recommended to avoid this issue? Choose 3 answers

Question49: A developer is creating a custom preference center and wants to log unsubscribeevents from the CloudPage.
Which set of parameters should be captured and provided to the LongUnsubEvent Execute Call to ensure accurate unsubscribe information?

Question50: An email requires custom AMPscript to append the subscriber's zip code to a link in theemail. A field name zipcode already exist in the sending data extension. Its important Marketing Cloud tracks subscribers who click on the link. Which two AMPscript functions should be used in the setup? Choose

Question51: A developer wants to expand their knowledge of Query Activities. They want to identify email addresses that have bounced in the last 30 days, along with the Bounce Reason and some additional subscriber specificdata; however, the SQL they have written does not return any records. Below is the SQL statement:

What updates should be made to ensure this SQL statement returns the desired results?

Question52: A doctor's office creates Populations for staff, patients and vendors. What is the maximum number of Populations that should be created to ensure performance?

Question53: A developer wants to write a query to compile data originating from an HTML form so it can be exported in CSV format. However, the source data extension may containline breaks within the Comments field, which makes it difficult to read and sort the resulting CSV.
Which SQL functions could be used to change each line break to a single space?

Question54: Which of the following statements are correct concerning Populations in Contact Builder? Choose 2.

Question55: A developer wants to use the RaiseError Ampscript function when a subscriber does not have the necessary data to build an email. Which two outcomes are possible using this function? Choose 2 answer

Question56: Which aspect should a developer consider before creating an Server-to-Server Installed Package and associated API Integration i* Marketing Cloud?

Question57: Certification Aid wants to implement a custom profile center using SOAP API. Which SOAP API methods are relevant to achieve this? Choose 2.

Question58: A developer wants to create a JavaScript Web Token using a key from Key Management.
What function should the developer use?

Question59: A developer wantsto implement a newsletter registration from on NTO's website. Prior to form submission, an email address provided by the visitor should be validated. Which option could be used to support this scenario?

Question60: A data extension contains two fields which are being populated by a query activity. A third field has recently been added to the data extension.
Which SELECT statement is optimal for returning all of the columns in the data extension?

Question61: Northern Trail Outfitters' legal team is concerned about the daily import process that brings in subscribers to a Sendable Data Extension, even when records have already been targeted for deletion.
Which two true expected behaviors for these recordsoccur in the event a send is initiated directly to this Sendable Data Extension?
Choose 2 answers

Question62: Northern Trail Outfitters is using a mobile campaign to collect email addresses of interested subscribers. Using AMPScript'sAPI functions they will send a confirmation email when an email is texted into their short code.
Which two objects are required to successfully create a TriggeredSend object? Choose 2 answers

Question63: What parameter should a developer include to ensure the MobileConnectContact is tied to the Email Contact when making a QueueMO call for an existing email subscriber?

Question64: A developer needs to identify all subscribers who were sent Job ID 420 but did not click any links.
Which SQL statement would produce the desired results?

Question65: A developer receives Error Code 5 when performing a SOAP API call. The error states: "Cannot Perform
'Post' on objects of type 'SentEvent'".
What could be the issue?

Question66: Which of the following statements are correct concerning Contacts and Subscribers? Choose 2.

Question67: A developer wants to design a custom subscription center in CloudPages. The developer prefers to code in AMPscript, but is also skilled in Server-Side JavaScript. While the developer is confident their code is of high quality, they would still like to handle unexprected errors gracefully to ensure the best user experience.
Whichfeature should handle this scenario?

Question68: A developer needs to process a payload from an external system in a CloudPage.
What Marketing Cloud Server-Side JavaScript Platform function should be used for converting a string payload in JSON format to a JavaScript object?

Question69: Northern Trail Outfitters' account is configured with two child BU(s): US and Global. The account has a dataextension In the Shared Data Extensions folder named 'MemberData'. This data extension contains basic address information, as well as Boolean fields labeled 'US' and 'Global' indicating to which business unit the subscriber belongs. Automation needs to becreated in the US business unit to query all records in New York who are members of the business unit US.
SELECT * FROM MemberData WHERE State = 'NY' AND US = 1
What would cause this query to report the following error: "An error occurred while checking the query syntax. Errors: MemberData is not a known data extension or system data view. You can only query existing data extensions or system data views."?

Question70: Certification Aid created a journey and event definition in Marketing Cloud. Which of the following resources are relevant to inject Contacts into the journey using the REST API? Choose 2.

Question71: A sendable data extension with a text field named 'Balance' contains the value S6.96 fora particular record.
The following AMPscript statement is included in an email:
IF (Balance > 6.00) THEN
SET @Result = 'Balance is more than $6.00
ENDIF
Why would this IF statement yield unintended results?

Question72: A developer is configuring a File Drop Automation and wantsto use a Filename Pattern to allow for timestamps on the file. The file name will always start with the month and day (e.g. MAY15) the file is dropped onto the SFTP site.
Which two configurations should be used for the automation to successfully start? Choose 2 answers

Question73: A developer needs to display a value which has been calculated using an AMPscript block. This value is stored in the variable named 'Label'.
Which two ways should the developer display this value in the body of an email? Choose 2 answers

Question74: A marketer is planning a weekly promotionalsend.
Which two types of data extensions could be sent to?
Choose 2 answers

Question75: A developer needs to determine why a Query Activity in an Automation has failed.
Which three scenarios could have caused this? Choose 3 answers

Question76: A developer wants to delete a batch of subscribers from Marketing Cloud. The developer performs a Contact Delete on a batch of records in a data extension in Contact Builder. Which scenario would cause subscriber records to remain in the data extension?

Question77: A developer wants to build an audience by identifying subscribers who opened a specific email. Which query should the developer use?

Question78: A marketer from Cloud Kicks wants to make sure no email from their welcome journey getssent to their competitor at Rainbow Run.
Which two best practices should the developer use when setting up the Send Email Activity in the welcome journey?
Choose 2 answers

Question79: Certification Aid wants to add new customers to a cross-channel welcome campaign when they register on the company website. Which API should be used for this? Choose 1.

Question80: A developer needs to add From Addresses to Marketing Cloud and wants to ensure they are verified before being used for sending.
Which tworoutes would allow this?
Choose 2 answers

Question81: Customer data has been imported into a staging data extension andneeds to be normalized before adding into the master data extension. A text field named 'birthday' contains date values in various formats. Some of the values are valid dates, but some are not.
Which SQL keywords and functions could be used to write the query'' Choose 2 answers

Question82: Certification Aid wants to automate the import of zipped files into a Data Extension. The zip files are placed on the Marketing Cloud Enhanced FTP server every night. Which activity is needed before those files can be imported? Choose 1.

Question83: Certification Aid wants to add records to a Data Extension using the SOAP API. Which object can be used for this? Choose 1.

Question84: How often should a developer request a new token when making multiple API calls in v1?

Question85: Which of the followingis a valid comment within an AMPscript code block? Choose 1.

Question86: A developer wants to retrieve a row of data from a data extension using the SOAP API. Which API Object should be used for this call?

Question87: A developer is writing a query to select unique subscribers who opened any emails sent since the beginning of the previous day.
Which querywould provide that result?

Question88: A developer wants to use the Marketing Cloud SOAP API to retrieve which subscribers were sent a particular email. Which SOAP API object should be used?

Question89: Northern Trail Outfitters has created subscriber attributes including AGE underProfile Manager within their Enterprise 2.0 account.
How would a developer retrieve subscribers over 30 years of age?

Question90: A developer wants CloudPages to work with a REST API returning data in JavaScript Object Notation. The developer wants to efficiently ingest the data and write it to a data extension.
Which function should be used?

Question91: A developer is managing the data model programmatically and needs to access Attribute Group schema via the API. Which API should the developer use?

Question92: New subscribers at Northern Trail Outfitters (NTO) are added to a data extension. NTO would like to send these subscribers a welcome series with Journey Builder.
What would allow the data extension to be selected for journey entry'

Question93: A developer wants to aggregate monthly energy usage data over a four month period for each subscriber within an email. The monthly usage values are stored in variables for eachmonth in the following way:
How should the developer use AMPscript to generate the total?

Question94: A developer wants to inject a Contact into a journey using API. What method and route would be used to accomplish this?

Question95: A company need to retrieve a large number of rows from a DE via the API. Which two solutions would optimize the performance? Choose2

Question96: A developer needs to create a fully-branded CloudPagewhich includes images hosted in Content Builder. The developer wants to secure the page and its elements using the SSL protocol.
What is the minimum number of SSL certificates required?